package top.yinhe.study.javawebjdbc.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBHelper {
  /* com.mysql.cj.jdbc.Driver */
//    数据库链接url
    public static final String URL =
          "jdbc:mysql://teach_mysql.huhuiyu.top:31000/db_zhumingzhang?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai";
//数据库用户名
    public  static final String USER = "db_zhumingzhang";
//数据库密码
public static final String PASSWORD = "zmz1029";
//数据库驱动类名称
public static final String DRIVER = "com.mysql.cj.jdbc.Driver";

static {
//    加载驱动程序
    try {
        Class.forName(DRIVER);
    } catch (ClassNotFoundException e) {
        throw new RuntimeException(e);
    }
    }


//    获取数据库链接
    public static Connection getConnection(){
        try {
            return DriverManager.getConnection(URL,USER, PASSWORD);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

}
